package com.framework.modules.sys.dao;

import com.framework.modules.sys.entity.SysRegionAreaEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 省市区 
 * 
 * @author MIT
 * @email litmiss@gmail.com
 * @date 2020-11-16 03:27:03
 */
public interface SysRegionAreaDao extends BaseMapper<SysRegionAreaEntity> {

    @Select("select id,pid,name,ext_name from sys_region_area where pid=#{pid}")
    List<Map<String,Object>> getRegionListByPid(Integer pid);

    @Select("select id,pid,name,ext_name from sys_region_area")
    List<Map<String,Object>> getAllRegionList();
	
}
